// 政策兑付明细表
const {DataTypes, db } = require("../db");
db.define('sendDfDetail', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,comment:''}, 
sendDfId:{type: DataTypes.INTEGER,comment:'主表ID'}, 
invId:{type: DataTypes.INTEGER,comment:'商品ID'}, 
brandId:{type: DataTypes.INTEGER,comment:'品牌ID'}, 
spec:{type: DataTypes.INTEGER,comment:'规格'}, 
unit:{type: DataTypes.STRING(12),comment:'单位'}, 
sendPrice:{type: DataTypes.FLOAT,comment:'兑付单价'}, 
dz:{type: DataTypes.FLOAT,comment:'搭赠数量'}, 
zz:{type: DataTypes.FLOAT,comment:'自赠数量'}, 
cl:{type: DataTypes.FLOAT,comment:'陈列数量'}, 
xl:{type: DataTypes.FLOAT,comment:'销量数量'}, 
ht:{type: DataTypes.FLOAT,comment:'合同数量'}, 
ky:{type: DataTypes.FLOAT,comment:'开业数量'}, 
zy:{type: DataTypes.FLOAT,comment:'赠饮数量'}, 
send:{type: DataTypes.STRING(12),comment:'赠品类型'}, 
bak2:{type: DataTypes.STRING(255),comment:''}, 
bak3:{type: DataTypes.STRING(255),comment:''}, 
bak4:{type: DataTypes.STRING(255),comment:''}, 
qty:{type: DataTypes.FLOAT,comment:'合计数量'}, 
amount:{type: DataTypes.DECIMAL(18, 2),comment:'合计金额'}, 
invoiceInfoId:{type: DataTypes.INTEGER,comment:'销售明细表Id'}, 
invoiceId:{type: DataTypes.INTEGER,comment:'销售表ID'}, 

}, {
    tableName: 'send_df_detail',
    timestamps: false,
    comment: '政策兑付明细表',
    
});